from handler.WorldBankExcelHandler import WorldBankExcelHandler

# 测试对象
if __name__ == '__main__':

    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SP.POP.TOTL_DS2_en_excel_v2_9_总人口.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_NY.GDP.MKTP.CD_DS2_en_excel_v2_124_GDP.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_NY.GDP.PCAP.CD_DS2_en_excel_v2_8_人均GDP.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_NY.GDP.MKTP.KD.ZG_DS2_en_excel_v2_58_GDP年增长率.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SP.POP.GROW_DS2_en_excel_v2_18_人口年增长率.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_GC.TAX.TOTL.CN_DS2_en_excel_v2_1687_国家税收.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_GC.TAX.TOTL.GD.ZS_DS2_en_excel_v2_1693_税收占GDP比重.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_GC.DOD.TOTL.GD.ZS_DS2_en_excel_v2_1609_中央政府债务.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_ER.GDP.FWTL.M3.KD_DS2_en_excel_v2_1420_产水金额.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_ER.H2O.FWTL.K3_DS2_en_excel_v2_1434_年取水量.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_ER.H2O.FWAG.ZS_DS2_en_excel_v2_1422_农业用水占比.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_ER.H2O.FWIN.ZS_DS2_en_excel_v2_1430_工业用水占比.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_ER.H2O.FWDM.ZS_DS2_en_excel_v2_1427_居民用水占比.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_EG.USE.ELEC.KH.PC_DS2_en_excel_v2_1192_人均电力消耗.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SH.H2O.SMDW.ZS_DS2_en_excel_v2_14679_获得可饮用水占人口比例.xls')
    # handler.read_filter_save()
    #
    # handler = WorldBankExcelHandler(
    #     r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SH.H2O.SMDW.UR.ZS_DS2_en_excel_v2_获得可饮用水占城镇人口比例15448.xls')
    # handler.read_filter_save()

    handler = WorldBankExcelHandler(
        r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SP.URB.TOTL_DS2_en_excel_v2_1050_城镇人口数量.xls')
    handler.read_filter_save()

    handler = WorldBankExcelHandler(
        r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SP.URB.TOTL.IN.ZS_DS2_en_excel_v2_121_城镇人口占比.xls')
    handler.read_filter_save()

    handler = WorldBankExcelHandler(
        r'D:\01.DOC\漏损产品\市场分析\原始数据\API_SP.URB.GROW_DS2_en_excel_v2_1784_城镇人口增长率.xls')
    handler.read_filter_save()
    pass
